home *** CD-ROM | disk | FTP | other *** search
/ Programming Languages Suite / ProgramD2.iso / Visual Database / Visual dBase Pro v7.0 / DATA1.CAB / Sample_dBASE / Fleet / Flight.sql < prev    next >
Encoding:
Text File  |  1997-11-20  |  333 b   |  6 lines
  1. --Database:FLEET
  2. SELECT Schedule."Flight ID", Schedule."Flight Date", Flight."To ID", Flight.DEPARTS, Flight.ARRIVES, Schedule."Aircraft ID", Flight."From ID"
  3. FROM "flight.dbf" Flight
  4.    INNER JOIN "schedule.dbf" Schedule
  5.    ON  (Flight."Flight ID" = Schedule."Flight ID")  
  6. ORDER BY Schedule."Flight ID", Schedule."Flight Date"